Primary Analysis
to-do
add intro/dialogue
Regression Tables
Table 1
##
## Regression Table 1
## ===========================================================================================
## Dependent variable:
## ------------------------------------------------------------------
## Sign Up
## (1) (2) (3) (4)
## -------------------------------------------------------------------------------------------
## Savings Rate 10% 0.125 0.126 0.126 0.127
## (0.090) (0.090) (0.090) (0.091)
##
## Savings Rate 20% 0.089 0.090 0.090 0.082
## (0.087) (0.087) (0.087) (0.087)
##
## Contract Length 25 Years -0.202*** -0.202*** -0.213***
## (0.076) (0.076) (0.076)
##
## Contract Length 20 Pages -0.046 -0.046 -0.053
## (0.072) (0.072) (0.073)
##
## Cancellation Fee 250 0.001 0.008
## (0.075) (0.075)
##
## High Income 0.210
## (0.137)
##
## Moderate Income 0.561***
## (0.120)
##
## Constant 0.304*** 0.426*** 0.425*** 0.118
## (0.073) (0.091) (0.097) (0.126)
##
## -------------------------------------------------------------------------------------------
## Observations 2,975 2,975 2,975 2,975
## R2 0.001 0.004 0.004 0.023
## chi2 1.964 (df = 2) 9.619** (df = 4) 9.619* (df = 5) 51.020*** (df = 7)
## ===========================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Table 2
##
## Regression Table 2
## ==========================================================================================================
## Dependent variable:
## ---------------------------------------------------------------------------------
## Sign Up
## (1) (2) (3) (4)
## ----------------------------------------------------------------------------------------------------------
## Savings Rate 10% 0.115 0.120 0.158* 0.159*
## (0.091) (0.091) (0.096) (0.096)
##
## Savings Rate 20% 0.077 0.078 0.117 0.120
## (0.088) (0.088) (0.094) (0.094)
##
## Contract Length 25 Years -0.209*** -0.223*** -0.229*** -0.226***
## (0.076) (0.077) (0.081) (0.081)
##
## Contract Length 20 Pages -0.065 -0.065 -0.067 -0.057
## (0.073) (0.073) (0.076) (0.076)
##
## Cancellation Fee 250 0.013 0.012 0.037 0.041
## (0.075) (0.076) (0.081) (0.081)
##
## High Income 0.290** 0.231 0.356** 0.348**
## (0.144) (0.146) (0.157) (0.158)
##
## Moderate Income 0.601*** 0.540*** 0.535*** 0.526***
## (0.122) (0.124) (0.132) (0.132)
##
## Black 0.075 0.162 0.089 0.073
## (0.146) (0.148) (0.156) (0.157)
##
## Hispanic 0.224 0.319** 0.169 0.160
## (0.153) (0.158) (0.169) (0.170)
##
## Asian -0.136 -0.072 -0.017 0.004
## (0.151) (0.154) (0.164) (0.164)
##
## Other 0.303* 0.376** 0.440** 0.442**
## (0.177) (0.179) (0.189) (0.190)
##
## Renter -0.327*** -0.092 -0.070
## (0.108) (0.116) (0.116)
##
## More Familiar 1.470*** 1.478***
## (0.110) (0.110)
##
## More Reviewed 0.256**
## (0.101)
##
## Constant 0.026 0.167 -0.738*** -0.905***
## (0.149) (0.157) (0.179) (0.189)
##
## ----------------------------------------------------------------------------------------------------------
## Observations 2,975 2,975 2,975 2,975
## R2 0.028 0.035 0.178 0.182
## chi2 62.852*** (df = 11) 79.180*** (df = 12) 421.368*** (df = 13) 430.983*** (df = 14)
## ==========================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Odds Ratios
Table 1
##
## Odds Ratio, Table 1
## ===========================================================================================
## Dependent variable:
## ------------------------------------------------------------------
## Sign Up
## (1) (2) (3) (4)
## -------------------------------------------------------------------------------------------
## Savings Rate 10% 1.133 1.134 1.134 1.136
## (1.094) (1.094) (1.094) (1.095)
##
## Savings Rate 20% 1.093 1.095 1.095 1.085
## (1.091) (1.091) (1.091) (1.091)
##
## Contract Length 25 Years 0.817 0.817 0.808
## (1.079) (1.079) (1.079)
##
## Contract Length 20 Pages 0.955 0.955 0.949
## (1.075) (1.075) (1.076)
##
## Cancellation Fee 250 1.001 1.008
## (1.078) (1.078)
##
## High Income 1.234
## (1.147)
##
## Moderate Income 1.752
## (1.127)
##
## Constant 1.355 1.531 1.530 1.126
## (1.076) (1.096) (1.101) (1.134)
##
## -------------------------------------------------------------------------------------------
## Observations 2,975 2,975 2,975 2,975
## R2 0.001 0.004 0.004 0.023
## chi2 1.964 (df = 2) 9.619** (df = 4) 9.619* (df = 5) 51.020*** (df = 7)
## ===========================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Table 2
##
## Odds Ratio, Table 2
## ==========================================================================================================
## Dependent variable:
## ---------------------------------------------------------------------------------
## Sign Up
## (1) (2) (3) (4)
## ----------------------------------------------------------------------------------------------------------
## Savings Rate 10% 1.121 1.128 1.172 1.172
## (1.095) (1.096) (1.101) (1.101)
##
## Savings Rate 20% 1.080 1.081 1.124 1.127
## (1.092) (1.092) (1.098) (1.098)
##
## Contract Length 25 Years 0.812 0.800 0.795 0.798
## (1.079) (1.080) (1.085) (1.085)
##
## Contract Length 20 Pages 0.937 0.937 0.935 0.944
## (1.076) (1.076) (1.079) (1.079)
##
## Cancellation Fee 250 1.014 1.012 1.038 1.042
## (1.078) (1.078) (1.084) (1.084)
##
## High Income 1.336 1.260 1.427 1.416
## (1.155) (1.157) (1.170) (1.171)
##
## Moderate Income 1.825 1.716 1.708 1.692
## (1.129) (1.132) (1.141) (1.141)
##
## Black 1.078 1.176 1.094 1.076
## (1.157) (1.159) (1.169) (1.170)
##
## Hispanic 1.251 1.376 1.184 1.173
## (1.166) (1.171) (1.184) (1.185)
##
## Asian 0.873 0.931 0.983 1.004
## (1.163) (1.166) (1.179) (1.179)
##
## Other 1.354 1.456 1.553 1.556
## (1.193) (1.196) (1.209) (1.209)
##
## Renter 0.721 0.912 0.932
## (1.114) (1.123) (1.123)
##
## More Familiar 4.349*** 4.382***
## (1.116) (1.116)
##
## More Reviewed 1.292
## (1.106)
##
## Constant 1.026 1.182 0.478 0.404
## (1.160) (1.170) (1.196) (1.208)
##
## ----------------------------------------------------------------------------------------------------------
## Observations 2,975 2,975 2,975 2,975
## R2 0.028 0.035 0.178 0.182
## chi2 62.852*** (df = 11) 79.180*** (df = 12) 421.368*** (df = 13) 430.983*** (df = 14)
## ==========================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01
Discussion
Main Takeaways
- Table 1
- Contract length of 25 years compared to 1 year remained a significant deterrent to contract acceptance rates.
- Relative to low income, moderate and higher income respondents were more likely to accept the contract, holding th effect of savings rate, cancellation fee, and contract length constant.
- Table 2
- Contract lenght remained a constant deterrance
- Homeowner status, rent vs homeowner, was not observed as a statistically significant effect on signup rate. Likely some multicollinearity due to effect (sign) varying from model 2 to model 4.
- After including familiarity and reviewed dummies, savings rate becomes statistically significant effect on likelihood of contract adoption.
- More familiar with community solar implies significantly more likely to adopt contract (suggests importance of education) - odds ratio of >4 in model 3 and 4
- In looking at contract adoption by race, Hispanics were the only group observed with a statistically significant effect in models 1 and 2. Relative to white, hispanic rates were higher. This effect is negated after additional IVs are introduces in models 3 and 4.
From Table 1, four models are presented analyzing changes in probability of sign up. Controlling for all other variables, contract length and income were found to have statistically significant effects on the rate of sign up. Contract length was found to have a strong negative impact on probability of contract adoption. For example, holding all variables constant, from model 2 we see that the odds ratio for contract length of 25 years is 0.782, meaning the group with contracts of 25 years are 0.782 times as likely as the group with contracts of 1 year of signing up, or a 21.8% decrease in odds of signing up.
Interestingly, lower income respondents were much less likely to adopt the contract, even when controlling for savings rate, contract length and number of pages, and cancellation fees. High income and medium income respondents were 1.3 and 1.7 times the odds to adopt the contract compared to low income respondents, controlling for contract attributes.